Global variable in Oracle [message #36742] |
Sun, 16 December 2001 20:50 |
RajuKVG
Messages: 13 Registered: December 2001
|
Junior Member |
|
|
Hi,
I want to use a global variable in oracle database. So that that variable is present accross all the sessions. Can any one help me how to get it, is there any package which helps achiveing this.
----------------------------------------------------------------------
|
|
|
|
Re: Global variable in Oracle [message #36749 is a reply to message #36742] |
Mon, 17 December 2001 07:37 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Suresh is right, a table is the only way. Packages support global variables at the session level - that is one of their main features.
----------------------------------------------------------------------
|
|
|
Re: Global variable in Oracle [message #36782 is a reply to message #36744] |
Thu, 20 December 2001 02:48 |
Phenoracle
Messages: 35 Registered: March 2001
|
Member |
|
|
Hi,
You could look at using DBMS_PIPE to hold a value
that can be viewed by all sessions.
This would mean placing the value back into the pipe, as an alternative to placing it in a table it is worth a look at.
Have fun
Phenom
----------------------------------------------------------------------
|
|
|